import connect
import close
'''
插入数据
'''
conn = connect.create_connect()
cursor = conn.cursor()
insert_data = "insert into create_test_01(name, age) values(%s, %s);"
# row = cursor.execute(insert_data,('jim',18))
# 批量
row = cursor.executemany(insert_data,[('tom',19),('Jerry',23)])
print(row)
conn.commit()
close.close(conn,cursor)